Interview Questions

1. What is role of ConfigurationManager?

Options:

a. It provides access to configuration files for client Applications.

b. It provides permission structure that allows methods or classes to access configuration files.

c. Represents a single, named connection string in the connection strings configuration file section.

d. Encapsulates the context information that is associated with a ConfigurationElement object

Reveal Answer

2. What is the return type of ExecuteNonQuery?

Options:

a. byte

b. short

c. int

d. string

Reveal Answer

3. Cursor managed by Data Reader is

Options:

a. read-only

b. Write-only

c. read-only and write-only

d. read-only and forward-only

Reveal Answer

4. What method is used by the Command classes to execute SQL statements that return single values?

Options:

a. ExecuteNonQuery()

b. ExecuteScalar()

c. ExecuteReader()

d. DataSet

Reveal Answer

5. What method is used by the Command classes to execute SQL statements that return the number of rows affected in the database?

Options:

a. ExecuteNonQuery()

b. ExecuteScalar()

c. ExecuteReader()

d. DataSet

Reveal Answer

6. What method is used by the Command classes to execute SQL statements that return multiple rows and columns?

Options:

a. ExecuteNonQuery()

b. ExecuteScalar()

c. ExecuteReader()

d. DataSet

Reveal Answer

7. Name the method that needs to be invoked on the DataAdapter control to fill the generated DataSet with data

Options:

a. Update()

b. Fill()

c. Read()

d. Open()

Reveal Answer

8. ADO.NET provides the ability to create and process in-memory databases called as__

Options:

a. Views

b. Relations

c. Tables

d. Datasets

Reveal Answer

9. Which of the following is the data provider for SQL Server?

Options:

a. Oledb

b. Odbc

c. Sqlclient

d. Sqltype

Reveal Answer

10. Dataset is used in ___ architecture

Options:

a. Disconnected oriented

b. Connected oriented

c. Both

d. none

Reveal Answer

11. ODBC provider is used for

Options:

a. MSAccess

b. Oracle

c. Sql server

d. Mysql

Reveal Answer

12. Which of the command objects, cannot be executed

Options:

a. Parameterized commands

b. Parameter less commands

c. Stored procedures

d. none

Reveal Answer

13. Which of the following file we can initialize ConnectionString information

Options:

a. App.config

b. Global.asax

c. Machine.config

d. None

Reveal Answer

14. Which keyword is used to accept a variable number of parameter in a method?

Options:

a. params

b. this

c. base

d. none of the above

Reveal Answer

15. How many DataReader objects can be opened on a connection object at a time by default?

Options:

a. One

b. Two

c. Zero

d. none of the above

Reveal Answer

16. Executenonquery() returns

Options:

a. Affected row collection

b. Count of rows affected

c. Void

d. Boolean value

Reveal Answer

17. What is the trusted authentication mode

Options:

a. Windows authentication

b. Sql server authentication

c. None

Reveal Answer

Interview Questions and Answer

1. What is role of ConfigurationManager?

2. What is the return type of ExecuteNonQuery?

3. Cursor managed by Data Reader is

4. What method is used by the Command classes to execute SQL statements that return single values?

5. What method is used by the Command classes to execute SQL statements that return the number of rows affected in the database?

6. What method is used by the Command classes to execute SQL statements that return multiple rows and columns?

7. Name the method that needs to be invoked on the DataAdapter control to fill the generated DataSet with data

8. ADO.NET provides the ability to create and process in-memory databases called as__

9. Which of the following is the data provider for SQL Server?

10. Dataset is used in ___ architecture

11. ODBC provider is used for

12. Which of the command objects, cannot be executed

13. Which of the following file we can initialize ConnectionString information

14. Which keyword is used to accept a variable number of parameter in a method?

15. How many DataReader objects can be opened on a connection object at a time by default?

16. Executenonquery() returns

17. What is the trusted authentication mode

Packages

Trending Certification Courses:

Microsoft Mock Exams:

Other links

About

Resources